﻿// Created by Windward Studios - no copyright is claimed. This code can be used in
// any manner by anyone for any reason. There is no copyright of any kind on it. You may
// use it in commercial products. You may change it without sharing those changes.
// We ask that you keep the "created by Windward Studios" in a comment at the top.

using System.Data.Common;

using net.windward.utils.ado.OleDb;

namespace net.windward.utils.ado.Excel
{
	/// <summary>
	/// Represents an Excel server.
	/// </summary>
	public class WrExcelServer : IWrServer
	{
        private readonly DbProviderFactory provider;
		private readonly string odbcProvider;
        private readonly string name;

		/// <summary>
		/// Create an Excel server object.
		/// </summary>
		/// <param name="provider">The provider for this server.</param>
		/// <param name="odbcProvider">The provider for this connection.</param>
		/// <param name="name">The name of the server.</param>
        public WrExcelServer(DbProviderFactory provider, string odbcProvider, string name)
		{
            this.provider = provider;
            this.odbcProvider = odbcProvider;
            this.name = name;
		}

        #region IWrServer Members

        /// <summary>
        /// The name of the server.
        /// </summary>
        public string Name
        {
            get { return name; }
        }

        /// <summary>
        /// All databases on this server. If a provider does not have the concept of databases (Oracle)
        /// it will always return 1 database.
        /// </summary>
        /// <param name="credentials">The user credentials to access the database.</param>
        /// <returns>All databases on this server.</returns>
        public IWrDatabase[] GetDatabases(WrCredentials credentials)
        {
            return null;
        }

        /// <summary>
        /// All databases on this server. If a provider does not have the concept of databases (Oracle)
        /// it will always return 1 database.
        /// </summary>
        /// <param name="connStr">The connection string to access the database.</param>
        /// <returns>All databases on this server.</returns>
        public IWrDatabase[] GetDatabases(string connStr)
        {
            return null;
        }

        #endregion

		/// <summary>
		/// Create a database object.
		/// </summary>
		/// <param name="database">The name of the database.</param>
		public IWrDatabase CreateDatabase(string database)
		{
            return new WrExcelDatabase(provider, odbcProvider, name);
		}

		/// <summary>
		/// Standard compare.
		/// </summary>
		/// <param name="obj">Object compared to.</param>
		/// <returns>-1, 0, or 1.</returns>
		public int CompareTo(object obj)
        {
            WrExcelServer db = obj as WrExcelServer;
            if (db == null)
                return 1;
            return name.CompareTo(db.name);
        }
	}
}
